//*Set Working Directory*//
cd "C:\Documents and Settings\mohara\Desktop\working_metelski"

/***********************************************/
/***   No need to change anything below here   **/

cd "Importable"

//*Import County Level Census Data 2006-2010*//
	import delimited "importable_census.csv.csv" 
	save census.dta, replace 
clear 

//*Import County Level Census Data 2011*//
	import delimited "importable_census2011.csv.csv" 
	save census2011.dta, replace 
clear 

//*Import State Level Census Data 2006-2010*//
	import delimited "importable_census_state.csv.csv" 
	save censusstate.dta, replace 
clear 

//*Import State Level Census Data 2011*//
	import delimited "importable_census_state2011.csv.csv" 
	save censusstate2011.dta, replace 
clear

//*Import Coal Mine Data*//
	import delimited "importable_2006Minedata.csv.csv" 
	save 2006minedata.dta, replace 
clear

//*Import 2006 Employment Data For All Industries*//
	import delimited "importable_2006all industries.csv.csv" 
	save 2006allindustries.dta, replace 
clear

//*Import 2006 Employment Data For Coal Industry*//
	import delimited "importable_2006Coal mining.csv.csv" 
	save 2006coal.dta, replace 
clear

//*Import 2006 Employment Data For Construction Industry*//
	import delimited "importable_2006Construction.csv.csv" 
	save 2006construction.dta, replace 
clear

//*Import 2006 Employment Data For Manufacturing Industry*//
	import delimited "importable_2006Manufacturing.csv.csv" 
	save 2006manufacturing.dta, replace 
clear

//*Import 2006 Employment Data For Retail Trade Industry*//
	import delimited "importable_2006Retail trade.csv.csv" 
	save 2006retailtrade.dta, replace 
clear

//*Import 2006 Employment Data For Service Industry*//
	import delimited "importable_2006Service-providing.csv.csv" 
	save 2006service.dta, replace 
clear

//*Import 2007 Employment Data For All Industries*//
	import delimited "importable_2007all industries.csv.csv" 
	save 2007allindustries.dta, replace 
clear

//*Import 2007 Employment Data For Coal Industry*//
	import delimited "importable_2007Coal mining.csv.csv" 
	save 2007coal.dta, replace 
clear

//*Import 2007 Employment Data For Construction Industry*//
	import delimited "importable_2007Construction.csv.csv" 
	save 2007construction.dta, replace 
clear

//*Import 2007 Employment Data For Manufacturing Industry*//
	import delimited "importable_2007Manufacturing.csv.csv" 
	save 2007manufacturing.dta, replace 
clear

//*Import 2007 Employment Data For Retail Trade Industry*//
	import delimited "importable_2007Retail trade.csv.csv" 
	save 2007retailtrade.dta, replace 
clear

//*Import 2007 Employment Data For Service Industry*//
	import delimited "importable_2007Service-providing.csv.csv" 
	save 2007service.dta, replace 
clear

//*Import 2008 Employment Data For All Industries*//
	import delimited "importable_2008all industries.csv.csv" 
	save 2008allindustries.dta, replace 
clear

//*Import 2008 Employment Data For Coal Industry*//
	import delimited "importable_2008Coal mining.csv.csv" 
	save 2008coal.dta, replace 
clear

//*Import 2008 Employment Data For Construction Industry*//
	import delimited "importable_2008Construction.csv.csv" 
	save 2008construction.dta, replace 
clear

//*Import 2008 Employment Data For Manufacturing Industry*//
	import delimited "importable_2008Manufacturing.csv.csv" 
	save 2008manufacturing.dta, replace 
clear

//*Import 2008 Employment Data For Retail Trade Industry*//
	import delimited "importable_2008Retail trade.csv.csv" 
	save 2008retailtrade.dta, replace 
clear

//*Import 2008 Employment Data For Service Industry*//
	import delimited "importable_2008Service-providing.csv.csv" 
	save 2008service.dta, replace 
clear

//*Import 2009 Employment Data For All Industries*//
	import delimited "importable_2009all industries.csv.csv" 
	save 2009allindustries.dta, replace 
clear

//*Import 2009 Employment Data For Coal Industry*//
	import delimited "importable_2009Coal mining.csv.csv" 
	save 2009coal.dta, replace 
clear

//*Import 2009 Employment Data For Construction Industry*//
	import delimited "importable_2009Construction.csv.csv" 
	save 2009construction.dta, replace 
clear

//*Import 2009 Employment Data For Manufacturing Industry*//
	import delimited "importable_2009Manufacturing.csv.csv" 
	save 2009manufacturing.dta, replace 
clear

//*Import 2009 Employment Data For Retail Trade Industry*//
	import delimited "importable_2009Retail trade.csv.csv" 
	save 2009retailtrade.dta, replace 
clear

//*Import 2009 Employment Data For Service Industry*//
	import delimited "importable_2009Service-providing.csv.csv" 
	save 2009service.dta, replace 
clear

//*Import 2010 Employment Data For All Industries*//
	import delimited "importable_2010all industries.csv.csv" 
	save 2010allindustries.dta, replace 
clear

//*Import 2010 Employment Data For Coal Industry*//
	import delimited "importable_2010Coal mining.csv.csv" 
	save 2010coal.dta, replace 
clear

//*Import 2010 Employment Data For Construction Industry*//
	import delimited "importable_2010Construction.csv.csv" 
	save 2010construction.dta, replace 
clear

//*Import 2010 Employment Data For Manufacturing Industry*//
	import delimited "importable_2010Manufacturing.csv.csv" 
	save 2010manufacturing.dta, replace 
clear

//*Import 2010 Employment Data For Retail Trade Industry*//
	import delimited "importable_2010Retail trade.csv.csv" 
	save 2010retailtrade.dta, replace 
clear

//*Import 2010 Employment Data For Service Industry*//
	import delimited "importable_2010Service-providing.csv.csv" 
	save 2010service.dta, replace 
clear

//*Import 2011 Employment Data For All Industries*//
	import delimited "importable_2011all industries.csv.csv" 
	save 2011allindustries.dta, replace 
clear

//*Import 2011 Employment Data For Coal Industry*//
	import delimited "importable_2011Coal mining.csv.csv" 
	save 2011coal.dta, replace 
clear

//*Import 2011 Employment Data For Construction Industry*//
	import delimited "importable_2011Construction.csv.csv" 
	save 2011construction.dta, replace 
clear

//*Import 2011 Employment Data For Manufacturing Industry*//
	import delimited "importable_2011Manufacturing.csv.csv" 
	save 2011manufacturing.dta, replace 
clear

//*Import 2011 Employment Data For Retail Trade Industry*//
	import delimited "importable_2011Retail trade.csv.csv" 
	save 2011retailtrade.dta, replace 
clear

//*Import 2011 Employment Data For Service Industry*//
	import delimited "importable_2011Service-providing.csv.csv" 
	save 2011service.dta, replace 
clear

//*Import State Unemployment Data for West Virginia*//
	import delimited "importable_WVstateunemployment.csv.csv" 
	save WVstateunemployment.dta , replace 
clear

//*Import State Unemployment Data for Kentucky*//
	import delimited "importable_KYstateunemployment.csv.csv" 
	save KYstateunemployment.dta , replace 
clear

//*Import County Unemployment Data for West Virginia*//
	import delimited "importable_WVcountyunemployment.csv.csv" 
	save WVcountyunemployment.dta , replace 
clear

//*Import County Unemployment Data for Kentucky*//
	import delimited "importable_KYcountyunemployment.csv.csv" 
	save KYcountyunemployment.dta , replace 
clear

cd ..
